<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use DB;

class Comcheckselfstep extends Model
{
    //
    protected $table = 'comcheckselfstep';

    public function getfiretype($companyId)
    {
    	$checkstep = DB::select("
            SELECT step.stepStatus,step.typeStatus FROM comcheckselfstep step
    			LEFT JOIN comcheckself on comcheckself.id = step.checkId 
    			WHERE comcheckself.companyId = $companyId 
            ");
        return $checkstep;
    }
}
